Stored Procedures [dbo].[BAEHistoryUpdate]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@HistoryIDint4
@EventDatedatetime8
@IPvarchar(128)128
@Descriptionvarchar(1024)1024
@EventTypevarchar(256)256
SQL Script
create procedure [dbo].[BAEHistoryUpdate] @HistoryID as
int,
    @EventDate AS datetime,
    @IP AS varchar(128),
    @Description AS varchar(1024),
    @EventType AS varchar(256)
AS
    UPDATE History
    SET
    EventDate =         @EventDate,            
    IP =     @IP,            
    Description = @Description,                
    EventType = @EventType            

    WHERE HistoryID = @HistoryID;

GO
Uses